#!/usr/bin/env python
# -*- coding: utf-8 -*-
#

import sqlite3
 
conn = sqlite3.connect("login.db") # or use :memory: to put it in RAM
 
cursor = conn.cursor()

 
# create a table
cursor.execute("""CREATE TABLE users (username,password,active)""")

users = [('Pedro', '1a1dc91c907325c69271ddf0c944bc72', '1'),
        ('Lindolfo', '1a1dc91c907325c69271ddf0c944bc72', '1'),
        ('Jasnau', '1a1dc91c907325c69271ddf0c944bc72', '1')]
		
cursor.executemany("INSERT INTO users VALUES (?,?,?)", users)
conn.commit()
